﻿CREATE TABLE [org].[Desk] (
    [DeskId]                      INT             NOT NULL,
    [DeskCode]                    CHAR (5)        NOT NULL,
    [DeskGlobalAccountCode]       CHAR (8)        NOT NULL,
    [DeskName]                    VARCHAR (50)    NOT NULL,
    [DeskDescription]             NVARCHAR (1000) NULL,
    [DeskFlashPnlMinThresholdGBP] DECIMAL (18, 2) NULL,
    [DeskFlashPnLMaxThresholdGBP] DECIMAL (18, 2) NULL,
    [DeskFlashManualUpload]       BIT             NOT NULL,
    [DeskFlashMurexUpload]        BIT             NOT NULL,
    [DeskStartDate]               DATE            NOT NULL,
    [DeskEndDate]                 DATE            NULL,
    [IsLatest]                    BIT             NOT NULL,
    [IsActive]                    BIT             NOT NULL,
    [IsInternal]                  BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([DeskId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

